Posted by arh922 on January 28, 2013 at 12:10pm
i am trying to execute this query
select * from friends where name like '%n%' and i have many names with n letter. but no results returned.
what is the issue with %n?
i am trying to execute this query
select * from friends where name like '%n%' and i have many names with n letter. but no results returned.
what is the issue with %n?
Comments
Where are you running this
Where are you running this query in Drupal or in MySQL tool?
If it is in Drupal. please paste the code snippers here.
-Imran
Drupal 6:<?php$results =
Drupal 6:
<?php$results = db_query('SELECT * from {friends} where name like "%%%s%%"', 'n');
?>
Change the 'n' at the end to whatever you are searching for.
Jaypan We build websites
Thank you
Thank you