Ask a question about MySQL.

Ask a question about MySQL

If a short string is stored in the database:
Ab
Bc
Cd

So the word on my hand is a long string, such as ABCD, so what should SQL do to match that character with the short Word records in the library? Do you want to use concat to be attached?

In addition, to save these short strings to the database, how to handle the security, there will be injection and other hidden dangers?
Thank you

Share to:

------Solution--------------------
Yes
SELECT * from Tbl_name where ' ABCD ' like concat ('% ', field_name, '% ')

