如何在PHP MySQL中构建查询字符串

Question

I'm building my php application that relates with a MySQL database. I have some problems doing specific queries since i'm not used doing complex ones. I want to find out how to build query string to do this: Based on "cad_proc" "sigla" i want to get "estado" from "juizo" to make sure that i'm looking for "cad_proc" that have "MG" on it.

Table1: cad_proc               
id - sigla  - ...             
01 - MG105  - ...                        
03 - M123   - ...            
Table2: juizo
sigla - estado -...
MG105 - MG
M123  - MG

My query so far is:

SELECT * FROM cad_processo WHERE sigla like '$UF';

Where $UF is an input from user.

Answer 1

I think this is your desired result

Select card_proc.*, juizo.estado from card_proc left join juizo on (card_proc.sigla=juizo.sigla) where card_proc.sigla like '%$UF%'

Or if you want to do exact match..

Select card_proc.*, juizo.estado from card_proc left join juizo on (card_proc.sigla=juizo.sigla) where card_proc.sigla = '$UF'

Updated query..

 Select card_proc.* from card_proc left join juizo on (card_proc.sigla=juizo.sigla) where juizo.estado = '$UF'