SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table phones ( public varchar(64), redirect varchar(64), domain varchar(64) ); insert into phones values (7495000001, 7499000101, 'domain1.ru'); create table prefixes ( domain varchar(64), prefix varchar(64), blwl int ); insert into prefixes values ('domain1.ru', 7950, 1); SELECT redirect, domain FROM phones WHERE public = 7495000001; SELECT phones.public, phones.domain, prefixes.prefix, prefixes.blwl FROM phones LEFT JOIN prefixes ON phones.domain = prefixes.domain AND "79507777777" LIKE CONCAT(prefix,'%') WHERE public = 7495000001 ORDER BY LENGTH(prefix) DESC LIMIT 1 /* public | domain | prefix | blwl ——————————————————————————————————————— 7495000001 | domain1.ru | 7950 | 1 Но если скажем по второму запросу ничего не находит то поля пустые: public | domain | prefix | blwl ——————————————————————————————————————— 7495000001 | domain1.ru | | */
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear