Using LIKE %

[obrienkev]

Hi all,

How do I know where to place the % on LIKE in a query??

How is LIKE %$name% different to LIKE %$name or LIKE $name% ?

Thanks.

Kevin.

[Roger_Ramjet]

% = wildcard. So it means

% . $var = match anything BEFORE
$var . % = match anything AFTER
% . $var . % = match anything BEFORE or AFTER