Querying mysql workbench for specific attribute -


in mysql workbench, want run:

select * testdatabase.testtable; 

but want restrict entries in table have specific attribute value, "userid"=123

how this? thank you.

just use where clause:

select * testdatabase.testtable userid = 123; 

this select rows table have userid 123.


Comments