Vjylku

What should be the ideal length of sentences in a blog post for ease of reading?

How to make a list of partial sums using forEach

How to reduce predictors the right way for a logistic regression model

Check if object is null and return null

Can I say "fingers" when referring to toes?

Visualizing the difference curve in a 2D plot?

Do you waste sorcery points if you try to apply metamagic to a spell from a scroll but fail to cast it?

Why the "ls" command is showing the permissions of files in a FAT32 partition?

Can I cause damage to electrical appliances by unplugging them when they are turned on?

How to preserve electronics (computers, iPads and phones) for hundreds of years

What is the meaning of "You've never met a graph you didn't like?"

Usage of an old photo with expired copyright

Are Captain Marvel's powers affected by Thanos breaking the Tesseract and claiming the stone?

Why is the principal energy of an electron lower for excited electrons in a higher energy state?

Why does the Persian emissary display a string of crowned skulls?

PTIJ: Which Dr. Seuss books should one obtain?

Anime with legendary swords made from talismans and a man who could change them with a shattered body

Is there a distance limit for minecart tracks?

Alignment of six matrices

Why is the Sun approximated as a black body at ~ 5800 K?

Why didn’t Eve recognize the little cockroach as a living organism?

How would you translate "more" for use as an interface button?

El Dorado Word Puzzle II: Videogame Edition

Did I make a mistake by ccing email to boss to others?

Search in PostGIS database string in multiple column

Column exists in DatabaseMetaData, but does not exist in relation?Determining the SRID of a dataset in PostGISRewriting query to match two points with linestring in different database table?Problem with nested query in PhP and PostGISGetting data type of each column from PostGIS table?PostGIS Group By ErrorST_MakeLine returns nullTilestache Multiple Grids results in PostGIS errorFind and remove portions of polygons from one geometry column that overlap from another geometry column in PostGISPostGIS, Generating a city “code” for every city on earth

0

I have a big problem with a query ....

SELECT * FROM teren WHERE ((owner LIKE '%$query1%') OR (address LIKE '%$query1%') OR (use LIKE '%$query1%') OR (description LIKE '%$query1%')) AND id_prim = $id_primarie

I have four columns from which I should look for the variable $ query1 in that way if, in a column, it finds 4-5 like letters then return it as a result ...

Now this does not work because if I write the first 3 letters it goes but if I already go on it does not work and returns null :(

postgis query php

share

asked 3 mins ago

CoderCoder42CoderCoder42

304

add a comment | 

0

I have a big problem with a query ....

SELECT * FROM teren WHERE ((owner LIKE '%$query1%') OR (address LIKE '%$query1%') OR (use LIKE '%$query1%') OR (description LIKE '%$query1%')) AND id_prim = $id_primarie

I have four columns from which I should look for the variable $ query1 in that way if, in a column, it finds 4-5 like letters then return it as a result ...

Now this does not work because if I write the first 3 letters it goes but if I already go on it does not work and returns null :(

postgis query php

share

asked 3 mins ago

CoderCoder42CoderCoder42

304

add a comment | 

I have a big problem with a query ....

SELECT * FROM teren WHERE ((owner LIKE '%$query1%') OR (address LIKE '%$query1%') OR (use LIKE '%$query1%') OR (description LIKE '%$query1%')) AND id_prim = $id_primarie

I have four columns from which I should look for the variable $ query1 in that way if, in a column, it finds 4-5 like letters then return it as a result ...

Now this does not work because if I write the first 3 letters it goes but if I already go on it does not work and returns null :(

postgis query php

share

asked 3 mins ago

CoderCoder42CoderCoder42

304

SELECT * FROM teren WHERE ((owner LIKE '%$query1%') OR (address LIKE '%$query1%') OR (use LIKE '%$query1%') OR (description LIKE '%$query1%')) AND id_prim = $id_primarie

share

asked 3 mins ago

CoderCoder42CoderCoder42

304

share

asked 3 mins ago

CoderCoder42CoderCoder42

304

asked 3 mins ago

CoderCoder42CoderCoder42

304

asked 3 mins ago

CoderCoder42CoderCoder42

304