[SQL] Wildcard in date field???

Hello, I need to make a query that will select items that have a date matching the current month for example. For June this means that any day between 2000-06-01 and 2000-06-30 are ok. To do that I need a wildcard like "%" to replace the actual day in the date field. Ex.: select * from item wh

Re: [SQL] order by accents?

Patrick Coulombe wrote: > > hi, > if I do a query like this one : > > SELECT name from medias ORDER BY name > > name > > > > > > > ÉCCC > > 6 rows > > Why the record : ÉCCC is at the end? > HOW can I fix this? > > Thank you > Patrick Hello, I have the same

[SQL] two table comparison: find a mismatch?

Hello, here is to table: Table "city" Attribute|Type | Modifier +-+- city_id| smallint| not null default nextval('seq_city'::text) region_id |

[SQL] select an entry with a NULL date field

Hello, I have a problem with PostgreSQL when I try to select or delete an entry with an empty date. That's a typical entry Table tbl_date - entry_id154 date_012000-01-15 date_02this date is NULL namemy_test - I want to