I want to explain basic searching techniques using SQL LIKE statement. Replace spaces Before executing SQL query searching word replace spaces with %(symbol) using PHP str_replace function. Here searching word jquery ajax spaces replaced with %(symbol)- jquery%ajax SQL ‘LIKE’ SELECT * FROM messages WHERE msg LIKE ‘%jquery%ajax%’ ; CODE: <?php if($_SERVER[“REQUEST_METHOD”] == “POST”) { $q=$_POST[‘q’]; …
Tag: SQL LIKE ST
Permanent link to this article: https://blog.openshell.in/2011/01/searching-techniques-with-sql/