In the example below I have a 'names' table and I want to find all names that contain' Taylor':
PHP Code:
$sql = ("SELECT * FROM `names` WHERE` name` LIKE '%Taylor%' ORDER BY `id` ASC");
The percentage symbol '%' indicates that the search must be carried out in both directions, that is: from left to right and the reverse.