Mostafa Maoui Mostafa Maoui -4 years ago 85
MySQL Question

SQL server query Like

I have this table and i want to write a query that display members with the street number is 163.

the table structure is like this:

no_membre nom_membre adresse
3167 DIANNE BRODEUR 1638, 200e Avenue
3168 RENE LACASSE 1638, 300e Avenue
3209 SUZANNE LARSEN 163, Principale
3210 SERENA BRODEUR 163, Secondaire
3210 SERENA BRODEUR 11638, Secondaire

Answer Source

The query will be like so:

SELECT no_membre, nom_membre, adresse FROM table_name WHERE addresse LIKE '163,%'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download