SQL WHERE CONCAT不喜欢

I try to make SQL to search some string in database. In this spesification, The SQL must be dont display one string in database.

my sql like this :

$query = "SELECT * FROM `chatuser` WHERE CONCAT( `fullname`,`image`) LIKE '%".$search_string."%' NOT (`$string is not be displayed`) " ;

is that possible ? Thanks for help

From the docs found at https://www.w3resource.com/mysql/comparision-functions-and-operators/not-like.php

Example: MySQL NOT LIKE operator with (%) percent

The following MySQL statement excludes those rows from the table author, having the 1st character of aut_name ‘W’.

Code:

SELECT aut_name, country
FROM author 
WHERE aut_name NOT LIKE 'W%';

And so it seems would work in your situation.

The correct syntax of LIKE and NOT LIKE as two conditions would be:

SELECT * FROM chatuser
WHERE CONCAT(CustomerName,ContactName) LIKE '%t%'
AND CONCAT(CustomerName,ContactName) NOT LIKE '%m%';

You miss AND Between conditions. Also you have to repeat CONCAT(CustomerName,ContactName).

In the example above we are looking for all CustomerName+ContactName with a t in any place but if it doesn't have an m in any place.