select substring(n_text,1, 30) || substring(substring(n_text, 31, 15), '[^ ]*') || ' ...' as n_text from texts

select t_add_date, SUBSTRING(t_add_date::character varying, 1, 19) from table where t_add_date < NOW()-'1 DAY'::interval
t_add_date substring
2010-03-10 21:26:49.928445 2010-03-10 21:26:49
2010-03-10 21:26:49.928445 2010-03-10 21:26:49

select SUBSTRING(schemat,’^(.+),’) from tabela_schematy
Dane:
public,data
Wynik:
public

function get_title(obj) {
 var title = ”;
 if(obj.getAttribute(‘title’)) {
  title = obj.getAttribute(‘title’);
  title = title.substring(5);
 }
 return {title:title,value:title};
}

select CASE WHEN LENGTH(kategoria)>21 THEN SUBSTRING(kategoria,1,22) ELSE kategoria END as kategoria from kategorie
select CASE WHEN LENGTH(kategoria)>21 THEN CONCAT(SUBSTRING(kategoria,1,22), ".") ELSE kategoria END as kategoria from kategorie

function next_day(f, step) {

 var data = f.value;
 var tab = data.split(„-”);

 var year = tab[0];
 var month = tab[1];
 var day = tab[2];
 var date = new Date(year, month-1, day);

 var now = date;
 now.setDate(now.getDate() + step);
 var year=now.getFullYear();
 var month=now.getMonth()+1;
 var day=now.getDate();

 month = „0″ + month;
 month = month.substring(month.length-2, month.length);

 day = „0″ + day;
 day = day.substring(day.length-2, day.length);

 return year+”-”+month+”-”+day;
}
uruchomienie

var f2 = forma.elements["departure_date"];
var f1 = forma.elements["arrival_date"];

f1.value = next_day(f1, 1);
f2.value = next_day(f2, 1);

lub

f1.value = next_day(f1, -1);
f2.value = next_day(f2, -1);

SELECT LOCATE( ' ', address ) pos, address, SUBSTRING_INDEX(address, ' ', -1), address REGEXP '[:digit:]' FROM hotele

SELECT LOCATE( ' ', address ) pos, address, SUBSTRING_INDEX( address, ' ', -1 ) , address REGEXP '[[:digit:]]' FROM hotele

SELECT LOCATE( ' ', address ) pos, address, SUBSTRING_INDEX( address, ' ', -1 ) , address REGEXP '[[:digit:]]' FROM hotele WHERE SUBSTRING_INDEX( address, ' ', -1 ) REGEXP '[[:digit:]]'

update hotele set nr_domu = SUBSTRING_INDEX( address, ' ', -1 ) WHERE SUBSTRING_INDEX( address, ' ', -1 ) REGEXP '[[:digit:]]'

SELECT LOCATE( ' ', REVERSE(address) ) pos, address, trim(SUBSTRING( address, 1, LENGTH(address) - LOCATE( ' ', REVERSE(address) ))) FROM hotele WHERE SUBSTRING_INDEX( address, ' ', -1 ) REGEXP '[[:digit:]]'

update hotele set ulica = trim(SUBSTRING( address, 1, LENGTH(address) - LOCATE( ' ', REVERSE(address) ))) WHERE SUBSTRING_INDEX( address, ' ', -1 ) REGEXP '[[:digit:]]'

<SCRIPT LANGUAGE=”JavaScript”>
<!–
 document.write(„:” + document.referrer.substring(0,255))
//–>
</SCRIPT>