Home • Database • MySQL Nov 23rd, 2021 at 05:09 PM

MySQL filter with like clause

1. Filter username start with a

SELECT id, email, username, photo FROM users WHERE username LIKE 'a%';

2. Filter username end with a

SELECT id, email, username, photo FROM users WHERE username LIKE '%a';

3. Filter username containing sh

SELECT id, email, username, photo FROM users WHERE username LIKE '%sh%';

4. Filter username exactly matching with jahid

SELECT id, email, username, photo FROM users WHERE username LIKE 'jahid';

/25