MySQL - You can find long records from the database by short ones - using LIKE and %. Is it possible vice versa? Find a short record in the database by the long one?

Question

MySQL

I have the following line in the database:
/seo
I need to /seo/newsget it from this. How can I do it?

Answer 1

$query = 'SELECT * FROM seo WHERE LOCATE(url, '/seo/news')=1';

Answer 2

And what's the problem: you swap the value and the field (you can add special characters to the field to determine how you plan to search). As an example:

SELECT value FROM setting WHERE '/seo/news' LIKE '%' || value || '%'