MySQL useful Query

Find out total count of row in mysql
select count(user_id) as user_id from ef_user_mst;

Use Not Like in Mysql
select * from table_name where column_name NOT LIKE '%Search_with%';