How to search for unexact keyword in SQL Query

Question

I am Trying to create a search bar to search for a Title that is stored in the table already using php. To find the title I have to input the exact title ex. Input: (Title) Output: (Title). I want it so all you have to do is type a part of the word and the query filters for the titles with those words: Input: (tle) Output: (Title, First_Title). Is this possible to do with the query or do I have to use something else? The $Unexact variable is the variable used as the input.

$name = mysql_query("SELECT * FROM information WHERE Title='".$UnExact."'") or die ('Error: '.mysql_error ());

Why are you using "mysql_"? It is deprecated. Use `mysqli_`. — Gordon Linoff, Sep 12 '17 at 22:57
I would use ILIKE '%$UnExact%' case insensitive, just in case (pun intended :D) — atomCode, Sep 12 '17 at 23:02
Oh wait you are using MySQL, which has no ILIKE I'm used to PostgreSQL. I still suggest a case insensitive match however. — atomCode, Sep 12 '17 at 23:07
Possible duplicate of [Search for string within text column in MySQL](https://stackoverflow.com/questions/2526772/search-for-string-within-text-column-in-mysql) — aknosis, Sep 12 '17 at 23:17
https://stackoverflow.com/questions/2876789/how-can-i-search-case-insensitive-in-a-column-using-like-wildcard — aknosis, Sep 12 '17 at 23:17

atomCode · Answer 1 · 2017-09-12T23:21:52.053

1

Try this (using mysqli extension)

$name = $mysqli->query("SELECT * FROM information WHERE LOWER(Title) LIKE '%". strtolower ($UnExact) ."%'");

edited Sep 12 '17 at 23:21

answered Sep 12 '17 at 23:14

atomCode

842
7
17

How to search for unexact keyword in SQL Query

1 Answers1